/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : restart_life

 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001

 Date: 16/07/2024 10:58:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for city_code
-- ----------------------------
DROP TABLE IF EXISTS `city_code`;
CREATE TABLE `city_code` (
  `province` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '省名',
  `city` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '市',
  `code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '编码'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='城市编码';

-- ----------------------------
-- Records of city_code
-- ----------------------------
BEGIN;
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('北京', '北京市', '101010100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('北京', '北京', '101010100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('上海', '上海', '101020100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('天津', '天津', '101030100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '石家庄', '101090101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '张家口', '101090301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '秦皇岛', '101091101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '沧洲', '101090701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '衡水', '101090801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '邢台', '101090901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '邯郸', '101091001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '保定', '101090201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '廊坊', '101090601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '天津', '101030100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '郑州', '101180101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '新乡', '101180301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '许昌', '101180401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '平顶山', '101180501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '信阳', '101180601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '南阳', '101180701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '开封', '101180801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '洛阳', '101180901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '商丘', '101181001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '焦作', '101181101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '鹤壁', '101181201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '濮阳', '101181301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '周口', '101181401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '漯河', '101181501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '驻马店', '101181601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '三门峡', '101181701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '济源', '101181801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('河北', '安阳', '101180201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '合肥', '101220101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '芜湖', '101220301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '淮南', '101220401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '马鞍山', '101220501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '安庆', '101220601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '宿州', '101220701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '阜阳', '101220801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '亳州', '101220901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '黄山', '101221001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '滁州', '101221101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '淮北', '101221201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '铜陵', '101221301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '宣城', '101221401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '六安', '101221501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '巢湖', '101221601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '池州', '101221701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('安徽', '蚌埠', '101220201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '杭州', '101210101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '舟山', '101211101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '湖州', '101210201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '嘉兴', '101210301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '金华', '101210901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '绍兴', '101210501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '台州', '101210601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '温州', '101210701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '丽水', '101210801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '衢州', '101211001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('浙江', '宁波', '101210401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '重庆', '101040100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '合川', '101040300');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '南川', '101040400');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '江津', '101040500');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '万盛', '101040600');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '渝北', '101040700');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '北碚', '101040800');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '巴南', '101040900');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '长寿', '101041000');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '黔江', '101041100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '万州天城', '101041200');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '万州龙宝', '101041300');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '涪陵', '101041400');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '开县', '101041500');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '城口', '101041600');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '云阳', '101041700');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '巫溪', '101041800');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '奉节', '101041900');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '巫山', '101042000');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '潼南', '101042100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '垫江', '101042200');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '梁平', '101042300');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '忠县', '101042400');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '石柱', '101042500');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '大足', '101042600');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '荣昌', '101042700');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '铜梁', '101042800');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '璧山', '101042900');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '丰都', '101043000');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '武隆', '101043100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '彭水', '101043200');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '綦江', '101043300');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '酉阳', '101043400');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '秀山', '101043600');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '沙坪坝', '101043700');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('重庆', '永川', '101040200');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '福州', '101230101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '泉州', '101230501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '漳州', '101230601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '龙岩', '101230701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '晋江', '101230509');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '南平', '101230901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '厦门', '101230201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '宁德', '101230301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '莆田', '101230401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('福建', '三明', '101230801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '兰州', '101160101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '平凉', '101160301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '庆阳', '101160401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '武威', '101160501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '金昌', '101160601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '嘉峪关', '101161401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '酒泉', '101160801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '天水', '101160901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '武都', '101161001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '临夏', '101161101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '合作', '101161201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '白银', '101161301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '定西', '101160201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('甘肃', '张掖', '101160701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '广州', '101280101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '惠州', '101280301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '梅州', '101280401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '汕头', '101280501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '深圳', '101280601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '珠海', '101280701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '佛山', '101280800');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '肇庆', '101280901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '湛江', '101281001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '江门', '101281101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '河源', '101281201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '清远', '101281301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '云浮', '101281401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '潮州', '101281501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '东莞', '101281601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '中山', '101281701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '阳江', '101281801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '揭阳', '101281901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '茂名', '101282001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '汕尾', '101282101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广东', '韶关', '101280201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '南宁', '101300101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '柳州', '101300301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '来宾', '101300401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '桂林', '101300501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '梧州', '101300601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '防城港', '101301401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '贵港', '101300801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '玉林', '101300901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '百色', '101301001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '钦州', '101301101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '河池', '101301201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '北海', '101301301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '崇左', '101300201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('广西', '贺州', '101300701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '贵阳', '101260101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '安顺', '101260301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '都匀', '101260401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '兴义', '101260906');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '铜仁', '101260601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '毕节', '101260701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '六盘水', '101260801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '遵义', '101260201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('贵州', '凯里', '101260501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '昆明', '101290101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '红河', '101290301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '文山', '101290601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '玉溪', '101290701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '楚雄', '101290801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '普洱', '101290901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '昭通', '101291001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '临沧', '101291101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '怒江', '101291201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '香格里拉', '101291301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '丽江', '101291401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '德宏', '101291501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '景洪', '101291601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '大理', '101290201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '曲靖', '101290401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('云南', '保山', '101290501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '呼和浩特', '101080101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '乌海', '101080301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '集宁', '101080401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '通辽', '101080501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '阿拉善左旗', '101081201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '鄂尔多斯', '101080701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '临河', '101080801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '锡林浩特', '101080901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '呼伦贝尔', '101081000');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '乌兰浩特', '101081101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '包头', '101080201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('内蒙古', '赤峰', '101080601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '南昌', '101240101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '上饶', '101240301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '抚州', '101240401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '宜春', '101240501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '鹰潭', '101241101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '赣州', '101240701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '景德镇', '101240801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '萍乡', '101240901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '新余', '101241001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '九江', '101240201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江西', '吉安', '101240601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '武汉', '101200101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '黄冈', '101200501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '荆州', '101200801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '宜昌', '101200901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '恩施', '101201001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '十堰', '101201101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '神农架', '101201201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '随州', '101201301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '荆门', '101201401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '天门', '101201501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '仙桃', '101201601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '潜江', '101201701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '襄樊', '101200201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '鄂州', '101200301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '孝感', '101200401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '黄石', '101200601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖北', '咸宁', '101200701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '成都', '101270101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '自贡', '101270301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '绵阳', '101270401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '南充', '101270501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '达州', '101270601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '遂宁', '101270701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '广安', '101270801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '巴中', '101270901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '泸州', '101271001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '宜宾', '101271101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '内江', '101271201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '资阳', '101271301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '乐山', '101271401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '眉山', '101271501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '凉山', '101271601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '雅安', '101271701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '甘孜', '101271801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '阿坝', '101271901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '德阳', '101272001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '广元', '101272101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('四川', '攀枝花', '101270201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('宁夏', '银川', '101170101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('宁夏', '中卫', '101170501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('宁夏', '固原', '101170401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('宁夏', '石嘴山', '101170201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('宁夏', '吴忠', '101170301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('青海', '西宁', '101150101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('青海', '黄南', '101150301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('青海', '海北', '101150801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('青海', '果洛', '101150501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('青海', '玉树', '101150601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('青海', '海西', '101150701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('青海', '海东', '101150201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('青海', '海南', '101150401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '济南', '101120101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '潍坊', '101120601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '临沂', '101120901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '菏泽', '101121001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '滨州', '101121101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '东营', '101121201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '威海', '101121301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '枣庄', '101121401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '日照', '101121501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '莱芜', '101121601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '聊城', '101121701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '青岛', '101120201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '淄博', '101120301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '德州', '101120401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '烟台', '101120501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '济宁', '101120701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山东', '泰安', '101120801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '西安', '101110101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '延安', '101110300');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '榆林', '101110401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '铜川', '101111001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '商洛', '101110601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '安康', '101110701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '汉中', '101110801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '宝鸡', '101110901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '咸阳', '101110200');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('陕西', '渭南', '101110501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '太原', '101100101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '临汾', '101100701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '运城', '101100801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '朔州', '101100901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '忻州', '101101001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '长治', '101100501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '大同', '101100201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '阳泉', '101100301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '晋中', '101100401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '晋城', '101100601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('山西', '吕梁', '101101100');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '乌鲁木齐', '101130101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '石河子', '101130301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '昌吉', '101130401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '吐鲁番', '101130501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '库尔勒', '101130601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '阿拉尔', '101130701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '阿克苏', '101130801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '喀什', '101130901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '伊宁', '101131001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '塔城', '101131101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '哈密', '101131201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '和田', '101131301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '阿勒泰', '101131401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '阿图什', '101131501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '博乐', '101131601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('新疆', '克拉玛依', '101130201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('西藏', '拉萨', '101140101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('西藏', '山南', '101140301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('西藏', '阿里', '101140701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('西藏', '昌都', '101140501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('西藏', '那曲', '101140601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('西藏', '日喀则', '101140201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('西藏', '林芝', '101140401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('台湾', '台北县', '101340101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('台湾', '高雄', '101340201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('台湾', '台中', '101340401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '海口', '101310101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '三亚', '101310201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '东方', '101310202');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '临高', '101310203');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '澄迈', '101310204');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '儋州', '101310205');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '昌江', '101310206');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '白沙', '101310207');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '琼中', '101310208');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '定安', '101310209');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '屯昌', '101310210');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '琼海', '101310211');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '文昌', '101310212');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '保亭', '101310214');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '万宁', '101310215');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '陵水', '101310216');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '西沙', '101310217');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '南沙岛', '101310220');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '乐东', '101310221');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '五指山', '101310222');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('海南', '琼山', '101310102');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '长沙', '101250101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '株洲', '101250301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '衡阳', '101250401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '郴州', '101250501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '常德', '101250601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '益阳', '101250700');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '娄底', '101250801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '邵阳', '101250901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '岳阳', '101251001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '张家界', '101251101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '怀化', '101251201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '黔阳', '101251301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '永州', '101251401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '吉首', '101251501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('湖南', '湘潭', '101250201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '南京', '101190101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '镇江', '101190301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '苏州', '101190401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '南通', '101190501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '扬州', '101190601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '宿迁', '101191301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '徐州', '101190801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '淮安', '101190901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '连云港', '101191001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '常州', '101191101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '泰州', '101191201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '无锡', '101190201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('江苏', '盐城', '101190701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '哈尔滨', '101050101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '牡丹江', '101050301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '佳木斯', '101050401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '绥化', '101050501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '黑河', '101050601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '双鸭山', '101051301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '伊春', '101050801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '大庆', '101050901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '七台河', '101051002');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '鸡西', '101051101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '鹤岗', '101051201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '齐齐哈尔', '101050201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('黑龙江', '大兴安岭', '101050701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '长春', '101060101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '延吉', '101060301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '四平', '101060401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '白山', '101060901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '白城', '101060601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '辽源', '101060701');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '松原', '101060801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '吉林', '101060201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('吉林', '通化', '101060501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '沈阳', '101070101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '鞍山', '101070301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '抚顺', '101070401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '本溪', '101070501');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '丹东', '101070601');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '葫芦岛', '101071401');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '营口', '101070801');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '阜新', '101070901');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '辽阳', '101071001');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '铁岭', '101071101');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '朝阳', '101071201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '盘锦', '101071301');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '大连', '101070201');
INSERT INTO `city_code` (`province`, `city`, `code`) VALUES ('辽宁', '锦州', '101070701');
COMMIT;

-- ----------------------------
-- Table structure for sms_log
-- ----------------------------
DROP TABLE IF EXISTS `sms_log`;
CREATE TABLE `sms_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` varchar(50) DEFAULT NULL COMMENT '用户id',
  `user_phone` varchar(20) NOT NULL DEFAULT '' COMMENT '手机号码',
  `content` varchar(100) NOT NULL DEFAULT '' COMMENT '短信内容',
  `mobile_code` varchar(50) NOT NULL DEFAULT '' COMMENT '手机验证码',
  `type` int NOT NULL DEFAULT '0' COMMENT '短信类型  1:注册  2:验证',
  `rec_date` datetime NOT NULL COMMENT '发送时间',
  `response_code` varchar(50) DEFAULT NULL COMMENT '发送短信返回码',
  `status` int NOT NULL DEFAULT '0' COMMENT '状态  1:有效  0：失效',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COMMENT='短信记录表';

-- ----------------------------
-- Records of sms_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
  `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '登录账号',
  `realname` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '真实姓名',
  `password` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
  `salt` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'md5密码盐',
  `avatar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `birthday` datetime DEFAULT NULL COMMENT '生日',
  `sex` tinyint(1) DEFAULT NULL COMMENT '性别(0-默认未知,1-男,2-女)',
  `email` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '电子邮件',
  `phone` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '电话',
  `org_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '机构编码',
  `status` tinyint(1) DEFAULT NULL COMMENT '性别(1-正常,2-冻结)',
  `del_flag` tinyint(1) DEFAULT NULL COMMENT '删除状态(0-正常,1-已删除)',
  `third_id` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '第三方登录的唯一标识',
  `third_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '第三方类型',
  `activiti_sync` tinyint(1) DEFAULT NULL COMMENT '同步工作流引擎(1-同步,0-不同步)',
  `work_no` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工号，唯一键',
  `post` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '职务，关联职务表',
  `telephone` varchar(45) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '座机号',
  `create_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '更新人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `user_identity` tinyint(1) DEFAULT NULL COMMENT '身份（1普通成员 2上级）',
  `depart_ids` longtext CHARACTER SET utf8mb3 COLLATE utf8_general_ci COMMENT '负责部门',
  `rel_tenant_ids` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '多租户标识',
  `client_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '设备ID',
  `addree_now` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '现住址',
  `uuid` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'uuid',
  `address_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '市级码',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uniq_sys_user_work_no` (`work_no`) USING BTREE,
  UNIQUE KEY `uniq_sys_user_username` (`username`) USING BTREE,
  UNIQUE KEY `uniq_sys_user_phone` (`phone`) USING BTREE,
  UNIQUE KEY `uniq_sys_user_email` (`email`) USING BTREE,
  KEY `idx_su_username` (`username`) USING BTREE,
  KEY `idx_su_status` (`status`) USING BTREE,
  KEY `idx_su_del_flag` (`del_flag`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `realname`, `password`, `salt`, `avatar`, `birthday`, `sex`, `email`, `phone`, `org_code`, `status`, `del_flag`, `third_id`, `third_type`, `activiti_sync`, `work_no`, `post`, `telephone`, `create_by`, `create_time`, `update_by`, `update_time`, `user_identity`, `depart_ids`, `rel_tenant_ids`, `client_id`, `addree_now`, `uuid`, `address_code`) VALUES ('22669cd8547540bc8b0dccb9cca304fd', '33', '李四', '123456', NULL, NULL, '2000-03-10 08:00:00', 1, '12345@163.com', '19907331529', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '湖南省长沙市岳麓区', '96f5e0b6b4a24966ba88b6efe3e17b3b', '长沙');
INSERT INTO `sys_user` (`id`, `username`, `realname`, `password`, `salt`, `avatar`, `birthday`, `sex`, `email`, `phone`, `org_code`, `status`, `del_flag`, `third_id`, `third_type`, `activiti_sync`, `work_no`, `post`, `telephone`, `create_by`, `create_time`, `update_by`, `update_time`, `user_identity`, `depart_ids`, `rel_tenant_ids`, `client_id`, `addree_now`, `uuid`, `address_code`) VALUES ('510d9a42-5403-42eb-b588-8a579094f7ab', '王五', '李四', '123456', NULL, NULL, '2000-03-10 08:00:00', 1, '123454@163.com', '19907330529', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '湖南省长沙市岳麓区', 'b12f12fb-3374-4f7c-9396-db7a069b7d66', '长沙');
INSERT INTO `sys_user` (`id`, `username`, `realname`, `password`, `salt`, `avatar`, `birthday`, `sex`, `email`, `phone`, `org_code`, `status`, `del_flag`, `third_id`, `third_type`, `activiti_sync`, `work_no`, `post`, `telephone`, `create_by`, `create_time`, `update_by`, `update_time`, `user_identity`, `depart_ids`, `rel_tenant_ids`, `client_id`, `addree_now`, `uuid`, `address_code`) VALUES ('ac703c20fb0847deadffdecd3a8b0249', '343', '李四', '123456', NULL, NULL, '2000-03-10 08:00:00', 1, '1234566@163.com', '19907331527', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '湖南省长沙市岳麓区', '23ba86b8a4ca44a3ad107a52754fb312', '长沙');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
